<!DOCTYPE html
  PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">

<head>
  <meta http-equiv="Content-Type" content="text/html; charset=<?php echo $cfg_soft_lang; ?>">
  <title>数据库维护--数据还原</title>
	<link rel="stylesheet" href="../static/css/bootstrap.min.css">
	<link href="../static/font-awesome/css/font-awesome.min.css" rel="stylesheet">
  <link href="css/base.css" rel="stylesheet" type="text/css">
  <script language="javascript">
    //获得选中文件的数据表
    function getCheckboxItem() {
      var myform = document.form1;
      var allSel = "";
      if (myform.bakfile.value) return myform.bakfile.value;
      for (i = 0; i < myform.bakfile.length; i++) {
        if (myform.bakfile[i].checked) {
          if (allSel == "")
            allSel = myform.bakfile[i].value;
          else
            allSel = allSel + "," + myform.bakfile[i].value;
        }
      }
      return allSel;
    }
    //反选
    function ReSel() {
      var myform = document.form1;
      for (i = 0; i < myform.bakfile.length; i++) {
        if (myform.bakfile[i].checked) myform.bakfile[i].checked = false;
        else myform.bakfile[i].checked = true;
      }
    }
    //全选
    function SelAll() {
      var myform = document.form1;
      for (i = 0; i < myform.bakfile.length; i++) {
        myform.bakfile[i].checked = true;
      }
    }
    //取消
    function NoneSel() {
      var myform = document.form1;
      for (i = 0; i < myform.bakfile.length; i++) {
        myform.bakfile[i].checked = false;
      }
    }
    //
    function checkSubmit() {
      var myform = document.form1;
      myform.bakfiles.value = getCheckboxItem();
      return true;
    }

  </script>
</head>

<body background='images/allbg.gif' leftmargin='8' topmargin='8'>
  <table width="99%" border="0" cellpadding="3" cellspacing="1" align="center" bgcolor="#D6D6D6" class="table maintable table-bordered mt-3">
    <tr>
      <td height="19" colspan="4" background="images/tbg.gif" bgcolor="#E7E7E7">
        <table width="96%" border="0" cellspacing="1" cellpadding="1" class="table table-borderless">
          <tr>
            <td width="24%"><strong>数据还原</strong></td>
            <td width="76%" align="right">
              <a href="sys_data.php" class="btn btn-secondary btn-sm">数据备份</a>
              <a href="sys_sql_query.php" class="btn btn-secondary btn-sm">SQL命令行工具</a>
            </td>
          </tr>
        </table>
      </td>
    </tr>
    <form name="form1" onSubmit="checkSubmit()" action="sys_data_done.php" method="post" target="stafrm">
      <input type='hidden' name='dopost' value='redat' />
      <input type='hidden' name='bakfiles' value='' />
      <tr bgcolor="#F7F8ED">
        <td height="24" colspan="4" valign="top">
          <strong>发现的备份文件：</strong>
          <?php if(count($filelists)==0) echo " 没找到任何备份文件... "; ?>
        </td>
      </tr>
      <?php
    for($i=0;$i<count($filelists);$i++)
    {
    	echo "<tr  bgcolor='#FFFFFF' align='center' height='24'>\r\n";
      $mtd = "<td width='10%'>
             <input name='bakfile' id='bakfile' type='checkbox' class='np' value='".$filelists[$i]."' checked='1' /> 
             </td>
             <td width='40%'>{$filelists[$i]}</td>\r\n";
      echo $mtd;
      if(isset($filelists[$i+1]))
      {
      	$i++;
      	$mtd = "<td width='10%'>
              <input name='bakfile' id='bakfile' type='checkbox' class='np' value='".$filelists[$i]."' checked='1' /> 
              </td>
              <td width='40%'>{$filelists[$i]}</td>\r\n";
        echo $mtd;
      }else{
      	echo "<td></td><td></td>\r\n";
      }
      echo "</tr>\r\n";
    }
    ?>
      <tr align="center" bgcolor="#FDFDEA">
        <td height="24" colspan="4">
          &nbsp;
          <button name="b1" type="button" id="b1" onClick="SelAll()" class="btn btn-secondary btn-sm">全选</button>
          &nbsp;
          <button name="b2" type="button" id="b2" onClick="ReSel()" class="btn btn-secondary btn-sm">反选</button>
          &nbsp;
          <button name="b3" type="button" id="b3" onClick="NoneSel()" class="btn btn-secondary btn-sm">取消</button>
        </td>
      </tr>
      <tr bgcolor="#F7F8ED">
        <td height="24" colspan="4" valign="top">
          <strong>附加参数：</strong>
        </td>
      </tr>
      <tr bgcolor="#FFFFFF">
        <td height="24" colspan="4">
          <label><input name="structfile" type="checkbox" class="np" id="structfile" value="<?php echo $structfile?>"
            checked='1' />
          还原表结构信息(<?php echo $structfile?>)</label>
          <label><input name="delfile" type="checkbox" class="np" id="delfile" value="1" />
          还原后删除备份文件</label></td>
      </tr>
      <tr bgcolor="#E3F4BB">
        <td height="33" colspan="4">
          &nbsp;
          <button type="submit" name="Submit" class="btn btn-secondary">开始还原数据</button>
        </td>
      </tr>
    </form>
    <tr bgcolor="#F7F8ED">
      <td height="24" colspan="4"><strong>进行状态： </strong></td>
    </tr>
    <tr bgcolor="#FFFFFF">
      <td height="180" colspan="4">
        <iframe name="stafrm" frameborder="0" id="stafrm" width="100%" height="100%"></iframe>
      </td>
    </tr>
  </table>
</body>

</html>